Dataset statistics
| Number of variables | 29 |
|---|---|
| Number of observations | 786363 |
| Missing cells | 0 |
| Missing cells (%) | 0.0% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 158.2 MiB |
| Average record size in memory | 211.0 B |
Variable types
| Numeric | 9 |
|---|---|
| Categorical | 17 |
| Boolean | 3 |
echoBuffer has constant value "" | Constant |
merchantCity has constant value "" | Constant |
merchantState has constant value "" | Constant |
merchantZip has constant value "" | Constant |
posOnPremises has constant value "" | Constant |
recurringAuthInd has constant value "" | Constant |
transactionDateTime has a high cardinality: 776637 distinct values | High cardinality |
merchantName has a high cardinality: 2490 distinct values | High cardinality |
currentExpDate has a high cardinality: 165 distinct values | High cardinality |
accountOpenDate has a high cardinality: 1820 distinct values | High cardinality |
dateOfLastAddressChange has a high cardinality: 2184 distinct values | High cardinality |
accountNumber is highly correlated with customerId | High correlation |
customerId is highly correlated with accountNumber | High correlation |
cardCVV is highly correlated with enteredCVV | High correlation |
enteredCVV is highly correlated with cardCVV | High correlation |
transactionDateTime is uniformly distributed | Uniform |
transactionAmount has 22225 (2.8%) zeros | Zeros |
currentBalance has 33678 (4.3%) zeros | Zeros |
Reproduction
| Analysis started | 2021-03-24 00:30:05.825878 |
|---|---|
| Analysis finished | 2021-03-24 00:33:53.413125 |
| Duration | 3 minutes and 47.59 seconds |
| Software version | pandas-profiling v2.11.0 |
| Download configuration | config.yaml |
| Distinct | 5000 |
|---|---|
| Distinct (%) | 0.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 537232599.5 |
|---|---|
| Minimum | 100088067 |
| Maximum | 999389635 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 6.0 MiB |
Quantile statistics
| Minimum | 100088067 |
|---|---|
| 5-th percentile | 151258718 |
| Q1 | 330133277 |
| median | 507456073 |
| Q3 | 767620004 |
| 95-th percentile | 948004238 |
| Maximum | 999389635 |
| Range | 899301568 |
| Interquartile range (IQR) | 437486727 |
Descriptive statistics
| Standard deviation | 255421092.3 |
|---|---|
| Coefficient of variation (CV) | 0.4754385578 |
| Kurtosis | -1.21865435 |
| Mean | 537232599.5 |
| Median Absolute Deviation (MAD) | 218237767 |
| Skewness | 0.1124155098 |
| Sum | 4.224598386 × 1014 |
| Variance | 6.52399344 × 1016 |
| Monotocity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 380680241 | 32850 | 4.2% |
| 882815134 | 13189 | 1.7% |
| 570884863 | 10867 | 1.4% |
| 246251253 | 10172 | 1.3% |
| 369308035 | 7229 | 0.9% |
| 724518977 | 6283 | 0.8% |
| 894938833 | 6101 | 0.8% |
| 419709514 | 5930 | 0.8% |
| 832842201 | 5850 | 0.7% |
| 208319653 | 5235 | 0.7% |
| Other values (4990) | 682657 |
| Value | Count | Frequency (%) |
| 100088067 | 75 | |
| 100108752 | 18 | < 0.1% |
| 100328049 | 103 | |
| 100663626 | 31 | < 0.1% |
| 100737756 | 178 |
| Value | Count | Frequency (%) |
| 999389635 | 9 | < 0.1% |
| 999283629 | 141 | < 0.1% |
| 999258704 | 88 | < 0.1% |
| 999257059 | 160 | < 0.1% |
| 999086814 | 677 |
| Distinct | 5000 |
|---|---|
| Distinct (%) | 0.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 537232599.5 |
|---|---|
| Minimum | 100088067 |
| Maximum | 999389635 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 6.0 MiB |
Quantile statistics
| Minimum | 100088067 |
|---|---|
| 5-th percentile | 151258718 |
| Q1 | 330133277 |
| median | 507456073 |
| Q3 | 767620004 |
| 95-th percentile | 948004238 |
| Maximum | 999389635 |
| Range | 899301568 |
| Interquartile range (IQR) | 437486727 |
Descriptive statistics
| Standard deviation | 255421092.3 |
|---|---|
| Coefficient of variation (CV) | 0.4754385578 |
| Kurtosis | -1.21865435 |
| Mean | 537232599.5 |
| Median Absolute Deviation (MAD) | 218237767 |
| Skewness | 0.1124155098 |
| Sum | 4.224598386 × 1014 |
| Variance | 6.52399344 × 1016 |
| Monotocity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 380680241 | 32850 | 4.2% |
| 882815134 | 13189 | 1.7% |
| 570884863 | 10867 | 1.4% |
| 246251253 | 10172 | 1.3% |
| 369308035 | 7229 | 0.9% |
| 724518977 | 6283 | 0.8% |
| 894938833 | 6101 | 0.8% |
| 419709514 | 5930 | 0.8% |
| 832842201 | 5850 | 0.7% |
| 208319653 | 5235 | 0.7% |
| Other values (4990) | 682657 |
| Value | Count | Frequency (%) |
| 100088067 | 75 | |
| 100108752 | 18 | < 0.1% |
| 100328049 | 103 | |
| 100663626 | 31 | < 0.1% |
| 100737756 | 178 |
| Value | Count | Frequency (%) |
| 999389635 | 9 | < 0.1% |
| 999283629 | 141 | < 0.1% |
| 999258704 | 88 | < 0.1% |
| 999257059 | 160 | < 0.1% |
| 999086814 | 677 |
creditLimit
Real number (ℝ≥0)
| Distinct | 10 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 10759.46446 |
|---|---|
| Minimum | 250 |
| Maximum | 50000 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 6.0 MiB |
Quantile statistics
| Minimum | 250 |
|---|---|
| 5-th percentile | 500 |
| Q1 | 5000 |
| median | 7500 |
| Q3 | 15000 |
| 95-th percentile | 50000 |
| Maximum | 50000 |
| Range | 49750 |
| Interquartile range (IQR) | 10000 |
Descriptive statistics
| Standard deviation | 11636.17489 |
|---|---|
| Coefficient of variation (CV) | 1.08148272 |
| Kurtosis | 5.173764693 |
| Mean | 10759.46446 |
| Median Absolute Deviation (MAD) | 5000 |
| Skewness | 2.280312163 |
| Sum | 8460844750 |
| Variance | 135400566.1 |
| Monotocity | Not monotonic |
Histogram with fixed size bins (bins=10)
| Value | Count | Frequency (%) |
| 5000 | 201863 | |
| 15000 | 139307 | |
| 7500 | 97913 | |
| 2500 | 75429 | 9.6% |
| 20000 | 68629 | 8.7% |
| 10000 | 56889 | 7.2% |
| 50000 | 48781 | 6.2% |
| 1000 | 36430 | 4.6% |
| 250 | 34025 | 4.3% |
| 500 | 27097 | 3.4% |
| Value | Count | Frequency (%) |
| 250 | 34025 | 4.3% |
| 500 | 27097 | 3.4% |
| 1000 | 36430 | 4.6% |
| 2500 | 75429 | 9.6% |
| 5000 | 201863 |
| Value | Count | Frequency (%) |
| 50000 | 48781 | 6.2% |
| 20000 | 68629 | |
| 15000 | 139307 | |
| 10000 | 56889 | |
| 7500 | 97913 |
availableMoney
Real number (ℝ)
| Distinct | 521915 |
|---|---|
| Distinct (%) | 66.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 6250.725369 |
|---|---|
| Minimum | -1005.63 |
| Maximum | 50000 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 6.0 MiB |
Quantile statistics
| Minimum | -1005.63 |
|---|---|
| 5-th percentile | 178.67 |
| Q1 | 1077.42 |
| median | 3184.86 |
| Q3 | 7500 |
| 95-th percentile | 19911.672 |
| Maximum | 50000 |
| Range | 51005.63 |
| Interquartile range (IQR) | 6422.58 |
Descriptive statistics
| Standard deviation | 8880.783989 |
|---|---|
| Coefficient of variation (CV) | 1.420760546 |
| Kurtosis | 10.27296495 |
| Mean | 6250.725369 |
| Median Absolute Deviation (MAD) | 2524.42 |
| Skewness | 2.999323595 |
| Sum | 4915339154 |
| Variance | 78868324.26 |
| Monotocity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 250 | 6015 | 0.8% |
| 5000 | 5400 | 0.7% |
| 15000 | 4254 | 0.5% |
| 7500 | 4069 | 0.5% |
| 500 | 2811 | 0.4% |
| 2500 | 2809 | 0.4% |
| 10000 | 2757 | 0.4% |
| 20000 | 2496 | 0.3% |
| 1000 | 1865 | 0.2% |
| 50000 | 1207 | 0.2% |
| Other values (521905) | 752680 |
| Value | Count | Frequency (%) |
| -1005.63 | 1 | |
| -972.12 | 1 | |
| -936.08 | 1 | |
| -930.55 | 1 | |
| -916.03 | 1 |
| Value | Count | Frequency (%) |
| 50000 | 1207 | |
| 49999.72 | 1 | < 0.1% |
| 49999.62 | 1 | < 0.1% |
| 49999.43 | 1 | < 0.1% |
| 49998.89 | 1 | < 0.1% |
| Distinct | 776637 |
|---|---|
| Distinct (%) | 98.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 6.0 MiB |
| 2016-12-25T14:04:15 | 4 |
|---|---|
| 2016-05-28T14:24:41 | 4 |
| 2016-08-26T03:09:48 | 3 |
| 2016-05-11T01:01:40 | 3 |
| 2016-04-14T13:11:10 | 3 |
| Other values (776632) |
Length
| Max length | 19 |
|---|---|
| Median length | 19 |
| Mean length | 19 |
| Min length | 19 |
Characters and Unicode
| Total characters | 14940897 |
|---|---|
| Distinct characters | 13 |
| Distinct categories | 4 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 766989 ? |
|---|---|
| Unique (%) | 97.5% |
Sample
| 1st row | 2016-08-13T14:27:32 |
|---|---|
| 2nd row | 2016-10-11T05:05:54 |
| 3rd row | 2016-11-08T09:18:39 |
| 4th row | 2016-12-10T02:14:50 |
| 5th row | 2016-03-24T21:04:46 |
| Value | Count | Frequency (%) |
| 2016-12-25T14:04:15 | 4 | < 0.1% |
| 2016-05-28T14:24:41 | 4 | < 0.1% |
| 2016-08-26T03:09:48 | 3 | < 0.1% |
| 2016-05-11T01:01:40 | 3 | < 0.1% |
| 2016-04-14T13:11:10 | 3 | < 0.1% |
| 2016-04-06T18:26:24 | 3 | < 0.1% |
| 2016-09-27T18:00:40 | 3 | < 0.1% |
| 2016-01-26T08:54:30 | 3 | < 0.1% |
| 2016-06-20T20:39:36 | 3 | < 0.1% |
| 2016-04-23T12:11:33 | 3 | < 0.1% |
| Other values (776627) | 786331 |
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| 2016-05-28t14:24:41 | 4 | < 0.1% |
| 2016-12-25t14:04:15 | 4 | < 0.1% |
| 2016-09-14t23:41:59 | 3 | < 0.1% |
| 2016-12-23t12:09:17 | 3 | < 0.1% |
| 2016-05-30t07:54:14 | 3 | < 0.1% |
| 2016-09-27t07:48:42 | 3 | < 0.1% |
| 2016-10-12t00:25:48 | 3 | < 0.1% |
| 2016-11-19t12:58:00 | 3 | < 0.1% |
| 2016-08-13t13:09:46 | 3 | < 0.1% |
| 2016-11-25t11:39:51 | 3 | < 0.1% |
| Other values (776627) | 786331 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 2588303 | |
| 1 | 2316631 | |
| 2 | 1900367 | |
| - | 1572726 | |
| : | 1572726 | |
| 6 | 1150941 | |
| T | 786363 | 5.3% |
| 3 | 695491 | 4.7% |
| 5 | 628805 | 4.2% |
| 4 | 623835 | 4.2% |
| Other values (3) | 1104709 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 11009082 | |
| Dash Punctuation | 1572726 | 10.5% |
| Other Punctuation | 1572726 | 10.5% |
| Uppercase Letter | 786363 | 5.3% |
Most frequent character per category
| Value | Count | Frequency (%) |
| 0 | 2588303 | |
| 1 | 2316631 | |
| 2 | 1900367 | |
| 6 | 1150941 | |
| 3 | 695491 | 6.3% |
| 5 | 628805 | 5.7% |
| 4 | 623835 | 5.7% |
| 8 | 369100 | 3.4% |
| 7 | 368189 | 3.3% |
| 9 | 367420 | 3.3% |
| Value | Count | Frequency (%) |
| - | 1572726 |
| Value | Count | Frequency (%) |
| T | 786363 |
| Value | Count | Frequency (%) |
| : | 1572726 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 14154534 | |
| Latin | 786363 | 5.3% |
Most frequent character per script
| Value | Count | Frequency (%) |
| 0 | 2588303 | |
| 1 | 2316631 | |
| 2 | 1900367 | |
| - | 1572726 | |
| : | 1572726 | |
| 6 | 1150941 | |
| 3 | 695491 | 4.9% |
| 5 | 628805 | 4.4% |
| 4 | 623835 | 4.4% |
| 8 | 369100 | 2.6% |
| Other values (2) | 735609 | 5.2% |
| Value | Count | Frequency (%) |
| T | 786363 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 14940897 |
Most frequent character per block
| Value | Count | Frequency (%) |
| 0 | 2588303 | |
| 1 | 2316631 | |
| 2 | 1900367 | |
| - | 1572726 | |
| : | 1572726 | |
| 6 | 1150941 | |
| T | 786363 | 5.3% |
| 3 | 695491 | 4.7% |
| 5 | 628805 | 4.2% |
| 4 | 623835 | 4.2% |
| Other values (3) | 1104709 |
| Distinct | 66038 |
|---|---|
| Distinct (%) | 8.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 136.985791 |
|---|---|
| Minimum | 0 |
| Maximum | 2011.54 |
| Zeros | 22225 |
| Zeros (%) | 2.8% |
| Memory size | 6.0 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 3.44 |
| Q1 | 33.65 |
| median | 87.9 |
| Q3 | 191.48 |
| 95-th percentile | 433.35 |
| Maximum | 2011.54 |
| Range | 2011.54 |
| Interquartile range (IQR) | 157.83 |
Descriptive statistics
| Standard deviation | 147.725569 |
|---|---|
| Coefficient of variation (CV) | 1.078400672 |
| Kurtosis | 6.446378027 |
| Mean | 136.985791 |
| Median Absolute Deviation (MAD) | 66.44 |
| Skewness | 2.092246265 |
| Sum | 107720557.5 |
| Variance | 21822.84374 |
| Monotocity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 22225 | 2.8% |
| 8.21 | 132 | < 0.1% |
| 49.3 | 125 | < 0.1% |
| 8.81 | 124 | < 0.1% |
| 4.39 | 120 | < 0.1% |
| 7.53 | 119 | < 0.1% |
| 8.22 | 117 | < 0.1% |
| 4.69 | 115 | < 0.1% |
| 8.04 | 112 | < 0.1% |
| 36.01 | 111 | < 0.1% |
| Other values (66028) | 763063 |
| Value | Count | Frequency (%) |
| 0 | 22225 | |
| 0.01 | 60 | < 0.1% |
| 0.02 | 56 | < 0.1% |
| 0.03 | 32 | < 0.1% |
| 0.04 | 56 | < 0.1% |
| Value | Count | Frequency (%) |
| 2011.54 | 1 | |
| 1905.3 | 1 | |
| 1873.97 | 1 | |
| 1780.6 | 1 | |
| 1772.63 | 1 |
| Distinct | 2490 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 6.0 MiB |
| Uber | 25613 |
|---|---|
| Lyft | 25523 |
| oldnavy.com | 16992 |
| staples.com | 16980 |
| alibaba.com | 16959 |
| Other values (2485) |
Length
| Max length | 30 |
|---|---|
| Median length | 13 |
| Mean length | 14.13677526 |
| Min length | 4 |
Characters and Unicode
| Total characters | 11116637 |
|---|---|
| Distinct characters | 64 |
| Distinct categories | 6 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 3 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | Uber |
|---|---|
| 2nd row | AMC #191138 |
| 3rd row | Play Store |
| 4th row | Play Store |
| 5th row | Tim Hortons #947751 |
| Value | Count | Frequency (%) |
| Uber | 25613 | 3.3% |
| Lyft | 25523 | 3.2% |
| oldnavy.com | 16992 | 2.2% |
| staples.com | 16980 | 2.2% |
| alibaba.com | 16959 | 2.2% |
| apple.com | 16898 | 2.1% |
| walmart.com | 16873 | 2.1% |
| cheapfast.com | 16858 | 2.1% |
| ebay.com | 16842 | 2.1% |
| target.com | 16813 | 2.1% |
| Other values (2480) | 600012 |
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| putt | 61424 | 3.8% |
| amc | 37942 | 2.3% |
| ecards | 33072 | 2.0% |
| ez | 30922 | 1.9% |
| services | 27996 | 1.7% |
| fresh | 26224 | 1.6% |
| uber | 25613 | 1.6% |
| lyft | 25523 | 1.6% |
| online | 24832 | 1.5% |
| gas | 23910 | 1.5% |
| Other values (2541) | 1318851 |
Most occurring characters
| Value | Count | Frequency (%) |
| 849946 | 7.6% | |
| e | 718185 | 6.5% |
| a | 653772 | 5.9% |
| s | 537605 | 4.8% |
| o | 535320 | 4.8% |
| t | 516495 | 4.6% |
| n | 462311 | 4.2% |
| i | 377087 | 3.4% |
| r | 343496 | 3.1% |
| c | 338300 | 3.0% |
| Other values (54) | 5784120 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 6435319 | |
| Decimal Number | 1973023 | 17.7% |
| Uppercase Letter | 1256921 | 11.3% |
| Space Separator | 849946 | 7.6% |
| Other Punctuation | 588811 | 5.3% |
| Dash Punctuation | 12617 | 0.1% |
Most frequent character per category
| Value | Count | Frequency (%) |
| S | 125613 | 10.0% |
| C | 116700 | 9.3% |
| P | 109916 | 8.7% |
| A | 93360 | 7.4% |
| M | 90446 | 7.2% |
| B | 86290 | 6.9% |
| F | 72510 | 5.8% |
| D | 72228 | 5.7% |
| R | 50488 | 4.0% |
| H | 47930 | 3.8% |
| Other values (15) | 391440 |
| Value | Count | Frequency (%) |
| e | 718185 | |
| a | 653772 | 10.2% |
| s | 537605 | 8.4% |
| o | 535320 | 8.3% |
| t | 516495 | 8.0% |
| n | 462311 | 7.2% |
| i | 377087 | 5.9% |
| r | 343496 | 5.3% |
| c | 338300 | 5.3% |
| l | 305047 | 4.7% |
| Other values (14) | 1647701 |
| Value | Count | Frequency (%) |
| 1 | 223145 | |
| 4 | 214795 | |
| 2 | 213836 | |
| 3 | 204038 | |
| 9 | 202519 | |
| 6 | 200498 | |
| 8 | 193623 | |
| 5 | 190057 | |
| 7 | 173770 | |
| 0 | 156742 |
| Value | Count | Frequency (%) |
| # | 332018 | |
| . | 213742 | |
| ' | 43051 | 7.3% |
| Value | Count | Frequency (%) |
| 849946 |
| Value | Count | Frequency (%) |
| - | 12617 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 7692240 | |
| Common | 3424397 |
Most frequent character per script
| Value | Count | Frequency (%) |
| e | 718185 | 9.3% |
| a | 653772 | 8.5% |
| s | 537605 | 7.0% |
| o | 535320 | 7.0% |
| t | 516495 | 6.7% |
| n | 462311 | 6.0% |
| i | 377087 | 4.9% |
| r | 343496 | 4.5% |
| c | 338300 | 4.4% |
| l | 305047 | 4.0% |
| Other values (39) | 2904622 |
| Value | Count | Frequency (%) |
| 849946 | ||
| # | 332018 | 9.7% |
| 1 | 223145 | 6.5% |
| 4 | 214795 | 6.3% |
| 2 | 213836 | 6.2% |
| . | 213742 | 6.2% |
| 3 | 204038 | 6.0% |
| 9 | 202519 | 5.9% |
| 6 | 200498 | 5.9% |
| 8 | 193623 | 5.7% |
| Other values (5) | 576237 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 11116637 |
Most frequent character per block
| Value | Count | Frequency (%) |
| 849946 | 7.6% | |
| e | 718185 | 6.5% |
| a | 653772 | 5.9% |
| s | 537605 | 4.8% |
| o | 535320 | 4.8% |
| t | 516495 | 4.6% |
| n | 462311 | 4.2% |
| i | 377087 | 3.4% |
| r | 343496 | 3.1% |
| c | 338300 | 3.0% |
| Other values (54) | 5784120 |
acqCountry
Categorical
| Distinct | 5 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 6.0 MiB |
| US | |
|---|---|
| 4562 | |
| MEX | 3130 |
| CAN | 2424 |
| PR | 1538 |
Length
| Max length | 3 |
|---|---|
| Median length | 2 |
| Mean length | 1.995460112 |
| Min length | 0 |
Characters and Unicode
| Total characters | 1569156 |
|---|---|
| Distinct characters | 10 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | US |
|---|---|
| 2nd row | US |
| 3rd row | US |
| 4th row | US |
| 5th row | US |
| Value | Count | Frequency (%) |
| US | 774709 | |
| 4562 | 0.6% | |
| MEX | 3130 | 0.4% |
| CAN | 2424 | 0.3% |
| PR | 1538 | 0.2% |
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| us | 774709 | |
| mex | 3130 | 0.4% |
| can | 2424 | 0.3% |
| pr | 1538 | 0.2% |
Most occurring characters
| Value | Count | Frequency (%) |
| U | 774709 | |
| S | 774709 | |
| M | 3130 | 0.2% |
| E | 3130 | 0.2% |
| X | 3130 | 0.2% |
| C | 2424 | 0.2% |
| A | 2424 | 0.2% |
| N | 2424 | 0.2% |
| P | 1538 | 0.1% |
| R | 1538 | 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 1569156 |
Most frequent character per category
| Value | Count | Frequency (%) |
| U | 774709 | |
| S | 774709 | |
| M | 3130 | 0.2% |
| E | 3130 | 0.2% |
| X | 3130 | 0.2% |
| C | 2424 | 0.2% |
| A | 2424 | 0.2% |
| N | 2424 | 0.2% |
| P | 1538 | 0.1% |
| R | 1538 | 0.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 1569156 |
Most frequent character per script
| Value | Count | Frequency (%) |
| U | 774709 | |
| S | 774709 | |
| M | 3130 | 0.2% |
| E | 3130 | 0.2% |
| X | 3130 | 0.2% |
| C | 2424 | 0.2% |
| A | 2424 | 0.2% |
| N | 2424 | 0.2% |
| P | 1538 | 0.1% |
| R | 1538 | 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1569156 |
Most frequent character per block
| Value | Count | Frequency (%) |
| U | 774709 | |
| S | 774709 | |
| M | 3130 | 0.2% |
| E | 3130 | 0.2% |
| X | 3130 | 0.2% |
| C | 2424 | 0.2% |
| A | 2424 | 0.2% |
| N | 2424 | 0.2% |
| P | 1538 | 0.1% |
| R | 1538 | 0.1% |
merchantCountryCode
Categorical
| Distinct | 5 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 6.0 MiB |
| US | |
|---|---|
| MEX | 3143 |
| CAN | 2426 |
| PR | 1559 |
| 724 |
Length
| Max length | 3 |
|---|---|
| Median length | 2 |
| Mean length | 2.005240582 |
| Min length | 0 |
Characters and Unicode
| Total characters | 1576847 |
|---|---|
| Distinct characters | 10 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | US |
|---|---|
| 2nd row | US |
| 3rd row | US |
| 4th row | US |
| 5th row | US |
| Value | Count | Frequency (%) |
| US | 778511 | |
| MEX | 3143 | 0.4% |
| CAN | 2426 | 0.3% |
| PR | 1559 | 0.2% |
| 724 | 0.1% |
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| us | 778511 | |
| mex | 3143 | 0.4% |
| can | 2426 | 0.3% |
| pr | 1559 | 0.2% |
Most occurring characters
| Value | Count | Frequency (%) |
| U | 778511 | |
| S | 778511 | |
| M | 3143 | 0.2% |
| E | 3143 | 0.2% |
| X | 3143 | 0.2% |
| C | 2426 | 0.2% |
| A | 2426 | 0.2% |
| N | 2426 | 0.2% |
| P | 1559 | 0.1% |
| R | 1559 | 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 1576847 |
Most frequent character per category
| Value | Count | Frequency (%) |
| U | 778511 | |
| S | 778511 | |
| M | 3143 | 0.2% |
| E | 3143 | 0.2% |
| X | 3143 | 0.2% |
| C | 2426 | 0.2% |
| A | 2426 | 0.2% |
| N | 2426 | 0.2% |
| P | 1559 | 0.1% |
| R | 1559 | 0.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 1576847 |
Most frequent character per script
| Value | Count | Frequency (%) |
| U | 778511 | |
| S | 778511 | |
| M | 3143 | 0.2% |
| E | 3143 | 0.2% |
| X | 3143 | 0.2% |
| C | 2426 | 0.2% |
| A | 2426 | 0.2% |
| N | 2426 | 0.2% |
| P | 1559 | 0.1% |
| R | 1559 | 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1576847 |
Most frequent character per block
| Value | Count | Frequency (%) |
| U | 778511 | |
| S | 778511 | |
| M | 3143 | 0.2% |
| E | 3143 | 0.2% |
| X | 3143 | 0.2% |
| C | 2426 | 0.2% |
| A | 2426 | 0.2% |
| N | 2426 | 0.2% |
| P | 1559 | 0.1% |
| R | 1559 | 0.1% |
posEntryMode
Categorical
| Distinct | 6 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 6.0 MiB |
| 05 | |
|---|---|
| 09 | |
| 02 | |
| 90 | 19576 |
| 80 | 15283 |
Length
| Max length | 2 |
|---|---|
| Median length | 2 |
| Mean length | 1.98968924 |
| Min length | 0 |
Characters and Unicode
| Total characters | 1564618 |
|---|---|
| Distinct characters | 5 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 02 |
|---|---|
| 2nd row | 09 |
| 3rd row | 09 |
| 4th row | 09 |
| 5th row | 02 |
| Value | Count | Frequency (%) |
| 05 | 315035 | |
| 09 | 236481 | |
| 02 | 195934 | |
| 90 | 19576 | 2.5% |
| 80 | 15283 | 1.9% |
| 4054 | 0.5% |
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| 05 | 315035 | |
| 09 | 236481 | |
| 02 | 195934 | |
| 90 | 19576 | 2.5% |
| 80 | 15283 | 2.0% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 782309 | |
| 5 | 315035 | |
| 9 | 256057 | 16.4% |
| 2 | 195934 | 12.5% |
| 8 | 15283 | 1.0% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 1564618 |
Most frequent character per category
| Value | Count | Frequency (%) |
| 0 | 782309 | |
| 5 | 315035 | |
| 9 | 256057 | 16.4% |
| 2 | 195934 | 12.5% |
| 8 | 15283 | 1.0% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 1564618 |
Most frequent character per script
| Value | Count | Frequency (%) |
| 0 | 782309 | |
| 5 | 315035 | |
| 9 | 256057 | 16.4% |
| 2 | 195934 | 12.5% |
| 8 | 15283 | 1.0% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1564618 |
Most frequent character per block
| Value | Count | Frequency (%) |
| 0 | 782309 | |
| 5 | 315035 | |
| 9 | 256057 | 16.4% |
| 2 | 195934 | 12.5% |
| 8 | 15283 | 1.0% |
posConditionCode
Categorical
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 6.0 MiB |
| 01 | |
|---|---|
| 08 | |
| 99 | 7533 |
| 409 |
Length
| Max length | 2 |
|---|---|
| Median length | 2 |
| Mean length | 1.998959768 |
| Min length | 0 |
Characters and Unicode
| Total characters | 1571908 |
|---|---|
| Distinct characters | 4 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 01 |
|---|---|
| 2nd row | 01 |
| 3rd row | 01 |
| 4th row | 01 |
| 5th row | 01 |
| Value | Count | Frequency (%) |
| 01 | 628787 | |
| 08 | 149634 | 19.0% |
| 99 | 7533 | 1.0% |
| 409 | 0.1% |
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| 01 | 628787 | |
| 08 | 149634 | 19.0% |
| 99 | 7533 | 1.0% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 778421 | |
| 1 | 628787 | |
| 8 | 149634 | 9.5% |
| 9 | 15066 | 1.0% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 1571908 |
Most frequent character per category
| Value | Count | Frequency (%) |
| 0 | 778421 | |
| 1 | 628787 | |
| 8 | 149634 | 9.5% |
| 9 | 15066 | 1.0% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 1571908 |
Most frequent character per script
| Value | Count | Frequency (%) |
| 0 | 778421 | |
| 1 | 628787 | |
| 8 | 149634 | 9.5% |
| 9 | 15066 | 1.0% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1571908 |
Most frequent character per block
| Value | Count | Frequency (%) |
| 0 | 778421 | |
| 1 | 628787 | |
| 8 | 149634 | 9.5% |
| 9 | 15066 | 1.0% |
merchantCategoryCode
Categorical
| Distinct | 19 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 6.0 MiB |
| online_retail | |
|---|---|
| fastfood | |
| entertainment | |
| food | |
| online_gifts | |
| Other values (14) |
Length
| Max length | 20 |
|---|---|
| Median length | 12 |
| Mean length | 9.93804388 |
| Min length | 3 |
Characters and Unicode
| Total characters | 7814910 |
|---|---|
| Distinct characters | 23 |
| Distinct categories | 4 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | rideshare |
|---|---|
| 2nd row | entertainment |
| 3rd row | mobileapps |
| 4th row | mobileapps |
| 5th row | fastfood |
| Value | Count | Frequency (%) |
| online_retail | 202156 | |
| fastfood | 112138 | |
| entertainment | 80098 | 10.2% |
| food | 75490 | 9.6% |
| online_gifts | 66238 | 8.4% |
| rideshare | 51136 | 6.5% |
| hotels | 34097 | 4.3% |
| fuel | 23910 | 3.0% |
| subscriptions | 22901 | 2.9% |
| auto | 21651 | 2.8% |
| Other values (9) | 96548 |
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| online_retail | 202156 | |
| fastfood | 112138 | |
| entertainment | 80098 | 9.9% |
| food | 75490 | 9.4% |
| online_gifts | 66238 | 8.2% |
| rideshare | 51136 | 6.3% |
| hotels | 34097 | 4.2% |
| fuel | 23910 | 3.0% |
| subscriptions | 22901 | 2.8% |
| auto | 21651 | 2.7% |
| Other values (10) | 115512 |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 991808 | |
| n | 876374 | |
| i | 806271 | |
| o | 791769 | |
| t | 737066 | |
| l | 615464 | |
| a | 555983 | |
| r | 492698 | |
| f | 403346 | 5.2% |
| s | 399467 | 5.1% |
| Other values (13) | 1144664 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 7509103 | |
| Connector Punctuation | 285461 | 3.7% |
| Space Separator | 18964 | 0.2% |
| Other Punctuation | 1382 | < 0.1% |
Most frequent character per category
| Value | Count | Frequency (%) |
| e | 991808 | |
| n | 876374 | |
| i | 806271 | |
| o | 791769 | |
| t | 737066 | |
| l | 615464 | |
| a | 555983 | |
| r | 492698 | |
| f | 403346 | |
| s | 399467 | |
| Other values (10) | 838857 |
| Value | Count | Frequency (%) |
| _ | 285461 |
| Value | Count | Frequency (%) |
| 18964 |
| Value | Count | Frequency (%) |
| / | 1382 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 7509103 | |
| Common | 305807 | 3.9% |
Most frequent character per script
| Value | Count | Frequency (%) |
| e | 991808 | |
| n | 876374 | |
| i | 806271 | |
| o | 791769 | |
| t | 737066 | |
| l | 615464 | |
| a | 555983 | |
| r | 492698 | |
| f | 403346 | |
| s | 399467 | |
| Other values (10) | 838857 |
| Value | Count | Frequency (%) |
| _ | 285461 | |
| 18964 | 6.2% | |
| / | 1382 | 0.5% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 7814910 |
Most frequent character per block
| Value | Count | Frequency (%) |
| e | 991808 | |
| n | 876374 | |
| i | 806271 | |
| o | 791769 | |
| t | 737066 | |
| l | 615464 | |
| a | 555983 | |
| r | 492698 | |
| f | 403346 | 5.2% |
| s | 399467 | 5.1% |
| Other values (13) | 1144664 |
| Distinct | 165 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 6.0 MiB |
| 03/2029 | 5103 |
|---|---|
| 08/2024 | 5087 |
| 10/2023 | 5075 |
| 05/2027 | 5063 |
| 01/2021 | 5041 |
| Other values (160) |
Length
| Max length | 7 |
|---|---|
| Median length | 7 |
| Mean length | 7 |
| Min length | 7 |
Characters and Unicode
| Total characters | 5504541 |
|---|---|
| Distinct characters | 11 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 06/2023 |
|---|---|
| 2nd row | 02/2024 |
| 3rd row | 08/2025 |
| 4th row | 08/2025 |
| 5th row | 10/2029 |
| Value | Count | Frequency (%) |
| 03/2029 | 5103 | 0.6% |
| 08/2024 | 5087 | 0.6% |
| 10/2023 | 5075 | 0.6% |
| 05/2027 | 5063 | 0.6% |
| 01/2021 | 5041 | 0.6% |
| 10/2032 | 5039 | 0.6% |
| 08/2030 | 5029 | 0.6% |
| 08/2022 | 5026 | 0.6% |
| 07/2031 | 5022 | 0.6% |
| 05/2026 | 5021 | 0.6% |
| Other values (155) | 735857 |
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| 03/2029 | 5103 | 0.6% |
| 08/2024 | 5087 | 0.6% |
| 10/2023 | 5075 | 0.6% |
| 05/2027 | 5063 | 0.6% |
| 01/2021 | 5041 | 0.6% |
| 10/2032 | 5039 | 0.6% |
| 08/2030 | 5029 | 0.6% |
| 08/2022 | 5026 | 0.6% |
| 07/2031 | 5022 | 0.6% |
| 05/2026 | 5021 | 0.6% |
| Other values (155) | 735857 |
Most occurring characters
| Value | Count | Frequency (%) |
| 2 | 1605016 | |
| 0 | 1558893 | |
| / | 786363 | |
| 1 | 441079 | 8.0% |
| 3 | 368935 | 6.7% |
| 7 | 125901 | 2.3% |
| 5 | 125315 | 2.3% |
| 6 | 124091 | 2.3% |
| 8 | 123490 | 2.2% |
| 4 | 123283 | 2.2% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 4718178 | |
| Other Punctuation | 786363 | 14.3% |
Most frequent character per category
| Value | Count | Frequency (%) |
| 2 | 1605016 | |
| 0 | 1558893 | |
| 1 | 441079 | 9.3% |
| 3 | 368935 | 7.8% |
| 7 | 125901 | 2.7% |
| 5 | 125315 | 2.7% |
| 6 | 124091 | 2.6% |
| 8 | 123490 | 2.6% |
| 4 | 123283 | 2.6% |
| 9 | 122175 | 2.6% |
| Value | Count | Frequency (%) |
| / | 786363 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 5504541 |
Most frequent character per script
| Value | Count | Frequency (%) |
| 2 | 1605016 | |
| 0 | 1558893 | |
| / | 786363 | |
| 1 | 441079 | 8.0% |
| 3 | 368935 | 6.7% |
| 7 | 125901 | 2.3% |
| 5 | 125315 | 2.3% |
| 6 | 124091 | 2.3% |
| 8 | 123490 | 2.2% |
| 4 | 123283 | 2.2% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 5504541 |
Most frequent character per block
| Value | Count | Frequency (%) |
| 2 | 1605016 | |
| 0 | 1558893 | |
| / | 786363 | |
| 1 | 441079 | 8.0% |
| 3 | 368935 | 6.7% |
| 7 | 125901 | 2.3% |
| 5 | 125315 | 2.3% |
| 6 | 124091 | 2.3% |
| 8 | 123490 | 2.2% |
| 4 | 123283 | 2.2% |
| Distinct | 1820 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 6.0 MiB |
| 2014-06-21 | 33623 |
|---|---|
| 2014-09-30 | 13335 |
| 2014-05-22 | 11353 |
| 2012-10-09 | 10867 |
| 2014-10-02 | 10653 |
| Other values (1815) |
Length
| Max length | 10 |
|---|---|
| Median length | 10 |
| Mean length | 10 |
| Min length | 10 |
Characters and Unicode
| Total characters | 7863630 |
|---|---|
| Distinct characters | 11 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 5 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | 2015-03-14 |
|---|---|
| 2nd row | 2015-03-14 |
| 3rd row | 2015-03-14 |
| 4th row | 2015-03-14 |
| 5th row | 2015-08-06 |
| Value | Count | Frequency (%) |
| 2014-06-21 | 33623 | 4.3% |
| 2014-09-30 | 13335 | 1.7% |
| 2014-05-22 | 11353 | 1.4% |
| 2012-10-09 | 10867 | 1.4% |
| 2014-10-02 | 10653 | 1.4% |
| 2014-11-05 | 6693 | 0.9% |
| 2014-12-04 | 6584 | 0.8% |
| 2015-03-01 | 5962 | 0.8% |
| 2015-02-21 | 5881 | 0.7% |
| 2015-08-14 | 5503 | 0.7% |
| Other values (1810) | 675909 |
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| 2014-06-21 | 33623 | 4.3% |
| 2014-09-30 | 13335 | 1.7% |
| 2014-05-22 | 11353 | 1.4% |
| 2012-10-09 | 10867 | 1.4% |
| 2014-10-02 | 10653 | 1.4% |
| 2014-11-05 | 6693 | 0.9% |
| 2014-12-04 | 6584 | 0.8% |
| 2015-03-01 | 5962 | 0.8% |
| 2015-02-21 | 5881 | 0.7% |
| 2015-08-14 | 5503 | 0.7% |
| Other values (1810) | 675909 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 1791694 | |
| - | 1572726 | |
| 1 | 1491726 | |
| 2 | 1339947 | |
| 5 | 425469 | 5.4% |
| 4 | 381282 | 4.8% |
| 3 | 264152 | 3.4% |
| 9 | 178943 | 2.3% |
| 6 | 158049 | 2.0% |
| 7 | 131384 | 1.7% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 6290904 | |
| Dash Punctuation | 1572726 | 20.0% |
Most frequent character per category
| Value | Count | Frequency (%) |
| 0 | 1791694 | |
| 1 | 1491726 | |
| 2 | 1339947 | |
| 5 | 425469 | 6.8% |
| 4 | 381282 | 6.1% |
| 3 | 264152 | 4.2% |
| 9 | 178943 | 2.8% |
| 6 | 158049 | 2.5% |
| 7 | 131384 | 2.1% |
| 8 | 128258 | 2.0% |
| Value | Count | Frequency (%) |
| - | 1572726 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 7863630 |
Most frequent character per script
| Value | Count | Frequency (%) |
| 0 | 1791694 | |
| - | 1572726 | |
| 1 | 1491726 | |
| 2 | 1339947 | |
| 5 | 425469 | 5.4% |
| 4 | 381282 | 4.8% |
| 3 | 264152 | 3.4% |
| 9 | 178943 | 2.3% |
| 6 | 158049 | 2.0% |
| 7 | 131384 | 1.7% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 7863630 |
Most frequent character per block
| Value | Count | Frequency (%) |
| 0 | 1791694 | |
| - | 1572726 | |
| 1 | 1491726 | |
| 2 | 1339947 | |
| 5 | 425469 | 5.4% |
| 4 | 381282 | 4.8% |
| 3 | 264152 | 3.4% |
| 9 | 178943 | 2.3% |
| 6 | 158049 | 2.0% |
| 7 | 131384 | 1.7% |
| Distinct | 2184 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 6.0 MiB |
| 2016-03-15 | 3819 |
|---|---|
| 2016-01-06 | 3740 |
| 2016-01-04 | 3558 |
| 2016-06-08 | 3355 |
| 2016-04-04 | 3194 |
| Other values (2179) |
Length
| Max length | 10 |
|---|---|
| Median length | 10 |
| Mean length | 10 |
| Min length | 10 |
Characters and Unicode
| Total characters | 7863630 |
|---|---|
| Distinct characters | 11 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 12 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | 2015-03-14 |
|---|---|
| 2nd row | 2015-03-14 |
| 3rd row | 2015-03-14 |
| 4th row | 2015-03-14 |
| 5th row | 2015-08-06 |
| Value | Count | Frequency (%) |
| 2016-03-15 | 3819 | 0.5% |
| 2016-01-06 | 3740 | 0.5% |
| 2016-01-04 | 3558 | 0.5% |
| 2016-06-08 | 3355 | 0.4% |
| 2016-04-04 | 3194 | 0.4% |
| 2016-02-22 | 3102 | 0.4% |
| 2016-03-23 | 3091 | 0.4% |
| 2016-04-07 | 3036 | 0.4% |
| 2016-05-19 | 2969 | 0.4% |
| 2016-01-01 | 2925 | 0.4% |
| Other values (2174) | 753574 |
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| 2016-03-15 | 3819 | 0.5% |
| 2016-01-06 | 3740 | 0.5% |
| 2016-01-04 | 3558 | 0.5% |
| 2016-06-08 | 3355 | 0.4% |
| 2016-04-04 | 3194 | 0.4% |
| 2016-02-22 | 3102 | 0.4% |
| 2016-03-23 | 3091 | 0.4% |
| 2016-04-07 | 3036 | 0.4% |
| 2016-05-19 | 2969 | 0.4% |
| 2016-01-01 | 2925 | 0.4% |
| Other values (2174) | 753574 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 1795546 | |
| - | 1572726 | |
| 1 | 1449902 | |
| 2 | 1258981 | |
| 6 | 557064 | 7.1% |
| 5 | 299459 | 3.8% |
| 4 | 243269 | 3.1% |
| 3 | 235552 | 3.0% |
| 9 | 157186 | 2.0% |
| 7 | 147127 | 1.9% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 6290904 | |
| Dash Punctuation | 1572726 | 20.0% |
Most frequent character per category
| Value | Count | Frequency (%) |
| 0 | 1795546 | |
| 1 | 1449902 | |
| 2 | 1258981 | |
| 6 | 557064 | 8.9% |
| 5 | 299459 | 4.8% |
| 4 | 243269 | 3.9% |
| 3 | 235552 | 3.7% |
| 9 | 157186 | 2.5% |
| 7 | 147127 | 2.3% |
| 8 | 146818 | 2.3% |
| Value | Count | Frequency (%) |
| - | 1572726 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 7863630 |
Most frequent character per script
| Value | Count | Frequency (%) |
| 0 | 1795546 | |
| - | 1572726 | |
| 1 | 1449902 | |
| 2 | 1258981 | |
| 6 | 557064 | 7.1% |
| 5 | 299459 | 3.8% |
| 4 | 243269 | 3.1% |
| 3 | 235552 | 3.0% |
| 9 | 157186 | 2.0% |
| 7 | 147127 | 1.9% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 7863630 |
Most frequent character per block
| Value | Count | Frequency (%) |
| 0 | 1795546 | |
| - | 1572726 | |
| 1 | 1449902 | |
| 2 | 1258981 | |
| 6 | 557064 | 7.1% |
| 5 | 299459 | 3.8% |
| 4 | 243269 | 3.1% |
| 3 | 235552 | 3.0% |
| 9 | 157186 | 2.0% |
| 7 | 147127 | 1.9% |
| Distinct | 899 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 544.4673376 |
|---|---|
| Minimum | 100 |
| Maximum | 998 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 6.0 MiB |
Quantile statistics
| Minimum | 100 |
|---|---|
| 5-th percentile | 141 |
| Q1 | 310 |
| median | 535 |
| Q3 | 785 |
| 95-th percentile | 948 |
| Maximum | 998 |
| Range | 898 |
| Interquartile range (IQR) | 475 |
Descriptive statistics
| Standard deviation | 261.5242203 |
|---|---|
| Coefficient of variation (CV) | 0.4803304114 |
| Kurtosis | -1.248157188 |
| Mean | 544.4673376 |
| Median Absolute Deviation (MAD) | 236 |
| Skewness | 0.046386637 |
| Sum | 428148969 |
| Variance | 68394.91778 |
| Monotocity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 869 | 33749 | 4.3% |
| 289 | 15509 | 2.0% |
| 640 | 10804 | 1.4% |
| 455 | 10279 | 1.3% |
| 959 | 7024 | 0.9% |
| 917 | 6503 | 0.8% |
| 548 | 5487 | 0.7% |
| 586 | 5245 | 0.7% |
| 296 | 5125 | 0.7% |
| 494 | 5038 | 0.6% |
| Other values (889) | 681600 |
| Value | Count | Frequency (%) |
| 100 | 192 | < 0.1% |
| 101 | 1000 | |
| 102 | 136 | < 0.1% |
| 103 | 224 | < 0.1% |
| 104 | 1303 |
| Value | Count | Frequency (%) |
| 998 | 850 | 0.1% |
| 997 | 314 | < 0.1% |
| 996 | 2294 | |
| 995 | 961 | |
| 994 | 118 | < 0.1% |
| Distinct | 976 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 544.1838566 |
|---|---|
| Minimum | 0 |
| Maximum | 998 |
| Zeros | 8 |
| Zeros (%) | < 0.1% |
| Memory size | 6.0 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 141 |
| Q1 | 310 |
| median | 535 |
| Q3 | 785 |
| 95-th percentile | 948 |
| Maximum | 998 |
| Range | 998 |
| Interquartile range (IQR) | 475 |
Descriptive statistics
| Standard deviation | 261.5512537 |
|---|---|
| Coefficient of variation (CV) | 0.4806303063 |
| Kurtosis | -1.246938755 |
| Mean | 544.1838566 |
| Median Absolute Deviation (MAD) | 236 |
| Skewness | 0.04621024635 |
| Sum | 427926050 |
| Variance | 68409.0583 |
| Monotocity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 869 | 33424 | 4.3% |
| 289 | 15401 | 2.0% |
| 640 | 10731 | 1.4% |
| 455 | 10176 | 1.3% |
| 959 | 6963 | 0.9% |
| 917 | 6440 | 0.8% |
| 548 | 5438 | 0.7% |
| 586 | 5202 | 0.7% |
| 296 | 5081 | 0.6% |
| 494 | 5005 | 0.6% |
| Other values (966) | 682502 |
| Value | Count | Frequency (%) |
| 0 | 8 | |
| 1 | 1 | < 0.1% |
| 3 | 6 | |
| 4 | 1 | < 0.1% |
| 5 | 2 | < 0.1% |
| Value | Count | Frequency (%) |
| 998 | 846 | 0.1% |
| 997 | 316 | < 0.1% |
| 996 | 2262 | |
| 995 | 950 | |
| 994 | 119 | < 0.1% |
cardLast4Digits
Real number (ℝ≥0)
| Distinct | 5245 |
|---|---|
| Distinct (%) | 0.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 4757.417799 |
|---|---|
| Minimum | 0 |
| Maximum | 9998 |
| Zeros | 5578 |
| Zeros (%) | 0.7% |
| Memory size | 6.0 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 482 |
| Q1 | 2178 |
| median | 4733 |
| Q3 | 7338 |
| 95-th percentile | 9522 |
| Maximum | 9998 |
| Range | 9998 |
| Interquartile range (IQR) | 5160 |
Descriptive statistics
| Standard deviation | 2996.58381 |
|---|---|
| Coefficient of variation (CV) | 0.6298761085 |
| Kurtosis | -1.277451616 |
| Mean | 4757.417799 |
| Median Absolute Deviation (MAD) | 2569 |
| Skewness | 0.07904789115 |
| Sum | 3741057333 |
| Variance | 8979514.53 |
| Monotocity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 593 | 32946 | 4.2% |
| 2194 | 10867 | 1.4% |
| 6002 | 10172 | 1.3% |
| 6580 | 6747 | 0.9% |
| 8502 | 6553 | 0.8% |
| 2178 | 5930 | 0.8% |
| 0 | 5578 | 0.7% |
| 7629 | 5235 | 0.7% |
| 2701 | 4826 | 0.6% |
| 2864 | 4533 | 0.6% |
| Other values (5235) | 692976 |
| Value | Count | Frequency (%) |
| 0 | 5578 | |
| 1 | 23 | < 0.1% |
| 2 | 495 | 0.1% |
| 3 | 71 | < 0.1% |
| 4 | 11 | < 0.1% |
| Value | Count | Frequency (%) |
| 9998 | 31 | < 0.1% |
| 9997 | 44 | < 0.1% |
| 9996 | 111 | |
| 9994 | 62 | |
| 9993 | 9 | < 0.1% |
transactionType
Categorical
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 6.0 MiB |
| PURCHASE | |
|---|---|
| REVERSAL | 20303 |
| ADDRESS_VERIFICATION | 20169 |
| 698 |
Length
| Max length | 20 |
|---|---|
| Median length | 8 |
| Mean length | 8.300680475 |
| Min length | 0 |
Characters and Unicode
| Total characters | 6527348 |
|---|---|
| Distinct characters | 17 |
| Distinct categories | 2 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | PURCHASE |
|---|---|
| 2nd row | PURCHASE |
| 3rd row | PURCHASE |
| 4th row | PURCHASE |
| 5th row | PURCHASE |
| Value | Count | Frequency (%) |
| PURCHASE | 745193 | |
| REVERSAL | 20303 | 2.6% |
| ADDRESS_VERIFICATION | 20169 | 2.6% |
| 698 | 0.1% |
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| purchase | 745193 | |
| reversal | 20303 | 2.6% |
| address_verification | 20169 | 2.6% |
Most occurring characters
| Value | Count | Frequency (%) |
| R | 826137 | |
| E | 826137 | |
| A | 805834 | |
| S | 805834 | |
| C | 765362 | |
| P | 745193 | |
| U | 745193 | |
| H | 745193 | |
| I | 60507 | 0.9% |
| V | 40472 | 0.6% |
| Other values (7) | 161486 | 2.5% |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 6507179 | |
| Connector Punctuation | 20169 | 0.3% |
Most frequent character per category
| Value | Count | Frequency (%) |
| R | 826137 | |
| E | 826137 | |
| A | 805834 | |
| S | 805834 | |
| C | 765362 | |
| P | 745193 | |
| U | 745193 | |
| H | 745193 | |
| I | 60507 | 0.9% |
| V | 40472 | 0.6% |
| Other values (6) | 141317 | 2.2% |
| Value | Count | Frequency (%) |
| _ | 20169 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 6507179 | |
| Common | 20169 | 0.3% |
Most frequent character per script
| Value | Count | Frequency (%) |
| R | 826137 | |
| E | 826137 | |
| A | 805834 | |
| S | 805834 | |
| C | 765362 | |
| P | 745193 | |
| U | 745193 | |
| H | 745193 | |
| I | 60507 | 0.9% |
| V | 40472 | 0.6% |
| Other values (6) | 141317 | 2.2% |
| Value | Count | Frequency (%) |
| _ | 20169 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 6527348 |
Most frequent character per block
| Value | Count | Frequency (%) |
| R | 826137 | |
| E | 826137 | |
| A | 805834 | |
| S | 805834 | |
| C | 765362 | |
| P | 745193 | |
| U | 745193 | |
| H | 745193 | |
| I | 60507 | 0.9% |
| V | 40472 | 0.6% |
| Other values (7) | 161486 | 2.5% |
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 6.0 MiB |
Length
| Max length | 0 |
|---|---|
| Median length | 0 |
| Mean length | 0 |
| Min length | 0 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | |
|---|---|
| 2nd row | |
| 3rd row | |
| 4th row | |
| 5th row |
| Value | Count | Frequency (%) |
| 786363 |
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
| Distinct | 487318 |
|---|---|
| Distinct (%) | 62.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 4508.739089 |
|---|---|
| Minimum | 0 |
| Maximum | 47498.81 |
| Zeros | 33678 |
| Zeros (%) | 4.3% |
| Memory size | 6.0 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 15.74 |
| Q1 | 689.91 |
| median | 2451.76 |
| Q3 | 5291.095 |
| 95-th percentile | 14600.382 |
| Maximum | 47498.81 |
| Range | 47498.81 |
| Interquartile range (IQR) | 4601.185 |
Descriptive statistics
| Standard deviation | 6457.442068 |
|---|---|
| Coefficient of variation (CV) | 1.432205754 |
| Kurtosis | 14.61307813 |
| Mean | 4508.739089 |
| Median Absolute Deviation (MAD) | 2010.45 |
| Skewness | 3.362136708 |
| Sum | 3545505596 |
| Variance | 41698558.06 |
| Monotocity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 33678 | 4.3% |
| 8.46 | 26 | < 0.1% |
| 5.67 | 19 | < 0.1% |
| 29.42 | 19 | < 0.1% |
| 59.68 | 18 | < 0.1% |
| 18.86 | 17 | < 0.1% |
| 10.04 | 17 | < 0.1% |
| 116.69 | 17 | < 0.1% |
| 117.28 | 16 | < 0.1% |
| 3.58 | 16 | < 0.1% |
| Other values (487308) | 752520 |
| Value | Count | Frequency (%) |
| 0 | 33678 | |
| 0.01 | 2 | < 0.1% |
| 0.02 | 5 | < 0.1% |
| 0.03 | 4 | < 0.1% |
| 0.04 | 4 | < 0.1% |
| Value | Count | Frequency (%) |
| 47498.81 | 1 | |
| 47496.84 | 1 | |
| 47496.32 | 1 | |
| 47493.83 | 1 | |
| 47493.74 | 1 |
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 6.0 MiB |
Length
| Max length | 0 |
|---|---|
| Median length | 0 |
| Mean length | 0 |
| Min length | 0 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | |
|---|---|
| 2nd row | |
| 3rd row | |
| 4th row | |
| 5th row |
| Value | Count | Frequency (%) |
| 786363 |
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 6.0 MiB |
Length
| Max length | 0 |
|---|---|
| Median length | 0 |
| Mean length | 0 |
| Min length | 0 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | |
|---|---|
| 2nd row | |
| 3rd row | |
| 4th row | |
| 5th row |
| Value | Count | Frequency (%) |
| 786363 |
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 6.0 MiB |
Length
| Max length | 0 |
|---|---|
| Median length | 0 |
| Mean length | 0 |
| Min length | 0 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | |
|---|---|
| 2nd row | |
| 3rd row | |
| 4th row | |
| 5th row |
| Value | Count | Frequency (%) |
| 786363 |
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
cardPresent
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 768.1 KiB |
| False | |
|---|---|
| True |
| Value | Count | Frequency (%) |
| False | 433495 | |
| True | 352868 |
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 6.0 MiB |
Length
| Max length | 0 |
|---|---|
| Median length | 0 |
| Mean length | 0 |
| Min length | 0 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | |
|---|---|
| 2nd row | |
| 3rd row | |
| 4th row | |
| 5th row |
| Value | Count | Frequency (%) |
| 786363 |
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 6.0 MiB |
Length
| Max length | 0 |
|---|---|
| Median length | 0 |
| Mean length | 0 |
| Min length | 0 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | |
|---|---|
| 2nd row | |
| 3rd row | |
| 4th row | |
| 5th row |
| Value | Count | Frequency (%) |
| 786363 |
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
expirationDateKeyInMatch
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 768.1 KiB |
| False | |
|---|---|
| True | 1043 |
| Value | Count | Frequency (%) |
| False | 785320 | |
| True | 1043 | 0.1% |
isFraud
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 768.1 KiB |
| False | |
|---|---|
| True | 12417 |
| Value | Count | Frequency (%) |
| False | 773946 | |
| True | 12417 | 1.6% |
Pearson's r
The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.
Spearman's ρ
The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.
Kendall's τ
Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.
Phik (φk)
Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here. A simple visualization of nullity by column.
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.
First rows
| accountNumber | customerId | creditLimit | availableMoney | transactionDateTime | transactionAmount | merchantName | acqCountry | merchantCountryCode | posEntryMode | posConditionCode | merchantCategoryCode | currentExpDate | accountOpenDate | dateOfLastAddressChange | cardCVV | enteredCVV | cardLast4Digits | transactionType | echoBuffer | currentBalance | merchantCity | merchantState | merchantZip | cardPresent | posOnPremises | recurringAuthInd | expirationDateKeyInMatch | isFraud | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 737265056 | 737265056 | 5000 | 5000.00 | 2016-08-13T14:27:32 | 98.55 | Uber | US | US | 02 | 01 | rideshare | 06/2023 | 2015-03-14 | 2015-03-14 | 414 | 414 | 1803 | PURCHASE | 0.00 | False | False | False | ||||||
| 1 | 737265056 | 737265056 | 5000 | 5000.00 | 2016-10-11T05:05:54 | 74.51 | AMC #191138 | US | US | 09 | 01 | entertainment | 02/2024 | 2015-03-14 | 2015-03-14 | 486 | 486 | 767 | PURCHASE | 0.00 | True | False | False | ||||||
| 2 | 737265056 | 737265056 | 5000 | 5000.00 | 2016-11-08T09:18:39 | 7.47 | Play Store | US | US | 09 | 01 | mobileapps | 08/2025 | 2015-03-14 | 2015-03-14 | 486 | 486 | 767 | PURCHASE | 0.00 | False | False | False | ||||||
| 3 | 737265056 | 737265056 | 5000 | 5000.00 | 2016-12-10T02:14:50 | 7.47 | Play Store | US | US | 09 | 01 | mobileapps | 08/2025 | 2015-03-14 | 2015-03-14 | 486 | 486 | 767 | PURCHASE | 0.00 | False | False | False | ||||||
| 4 | 830329091 | 830329091 | 5000 | 5000.00 | 2016-03-24T21:04:46 | 71.18 | Tim Hortons #947751 | US | US | 02 | 01 | fastfood | 10/2029 | 2015-08-06 | 2015-08-06 | 885 | 885 | 3143 | PURCHASE | 0.00 | True | False | False | ||||||
| 5 | 830329091 | 830329091 | 5000 | 5000.00 | 2016-04-19T16:24:27 | 30.76 | In-N-Out #422833 | US | US | 02 | 01 | fastfood | 01/2020 | 2015-08-06 | 2015-08-06 | 885 | 885 | 3143 | PURCHASE | 0.00 | True | False | False | ||||||
| 6 | 830329091 | 830329091 | 5000 | 5000.00 | 2016-05-21T14:50:35 | 57.28 | Krispy Kreme #685312 | US | US | 02 | 01 | fastfood | 05/2020 | 2015-08-06 | 2015-08-06 | 885 | 885 | 3143 | PURCHASE | 0.00 | True | False | False | ||||||
| 7 | 830329091 | 830329091 | 5000 | 5000.00 | 2016-06-03T00:31:21 | 9.37 | Shake Shack #968081 | US | US | 05 | 01 | fastfood | 01/2021 | 2015-08-06 | 2015-08-06 | 885 | 885 | 3143 | PURCHASE | 0.00 | True | False | False | ||||||
| 8 | 830329091 | 830329091 | 5000 | 4990.63 | 2016-06-10T01:21:46 | 523.67 | Burger King #486122 | US | 02 | 01 | fastfood | 08/2032 | 2015-08-06 | 2015-08-06 | 885 | 885 | 3143 | PURCHASE | 9.37 | True | False | False | |||||||
| 9 | 830329091 | 830329091 | 5000 | 5000.00 | 2016-07-11T10:47:16 | 164.37 | Five Guys #510989 | US | US | 05 | 08 | fastfood | 04/2020 | 2015-08-06 | 2015-08-06 | 885 | 885 | 3143 | PURCHASE | 0.00 | True | False | False |
Last rows
| accountNumber | customerId | creditLimit | availableMoney | transactionDateTime | transactionAmount | merchantName | acqCountry | merchantCountryCode | posEntryMode | posConditionCode | merchantCategoryCode | currentExpDate | accountOpenDate | dateOfLastAddressChange | cardCVV | enteredCVV | cardLast4Digits | transactionType | echoBuffer | currentBalance | merchantCity | merchantState | merchantZip | cardPresent | posOnPremises | recurringAuthInd | expirationDateKeyInMatch | isFraud | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 786353 | 732852505 | 732852505 | 50000 | 49796.87 | 2016-12-10T12:24:38 | 190.41 | EZ Putt Putt #804489 | US | US | 09 | 01 | entertainment | 06/2029 | 2012-08-23 | 2012-08-23 | 936 | 936 | 3783 | PURCHASE | 203.13 | True | False | False | ||||||
| 786354 | 732852505 | 732852505 | 50000 | 49606.46 | 2016-12-10T23:29:11 | 83.97 | KFC #206511 | US | US | 05 | 08 | fastfood | 12/2030 | 2012-08-23 | 2012-08-23 | 939 | 939 | 3388 | PURCHASE | 393.54 | True | False | False | ||||||
| 786355 | 732852505 | 732852505 | 50000 | 49522.49 | 2016-12-18T14:06:34 | 157.22 | Uber | US | US | 09 | 01 | rideshare | 08/2029 | 2012-08-23 | 2012-08-23 | 936 | 936 | 3783 | PURCHASE | 477.51 | False | False | False | ||||||
| 786356 | 732852505 | 732852505 | 50000 | 49365.27 | 2016-12-19T03:25:53 | 408.83 | Lyft | US | US | 09 | 01 | rideshare | 06/2021 | 2012-08-23 | 2012-08-23 | 939 | 939 | 3388 | PURCHASE | 634.73 | False | False | False | ||||||
| 786357 | 732852505 | 732852505 | 50000 | 48956.44 | 2016-12-22T07:27:23 | 51.48 | Sunoco Gas #380975 | US | US | 05 | 08 | fuel | 07/2032 | 2012-08-23 | 2012-08-23 | 936 | 936 | 3783 | PURCHASE | 1043.56 | True | False | False | ||||||
| 786358 | 732852505 | 732852505 | 50000 | 48904.96 | 2016-12-22T18:44:12 | 119.92 | Lyft | US | US | 90 | 01 | rideshare | 12/2022 | 2012-08-23 | 2012-08-23 | 936 | 936 | 3783 | PURCHASE | 1095.04 | False | False | False | ||||||
| 786359 | 732852505 | 732852505 | 50000 | 48785.04 | 2016-12-25T16:20:34 | 18.89 | hulu.com | US | US | 09 | 01 | online_subscriptions | 08/2023 | 2012-08-23 | 2012-08-23 | 939 | 939 | 3388 | PURCHASE | 1214.96 | False | False | False | ||||||
| 786360 | 732852505 | 732852505 | 50000 | 48766.15 | 2016-12-27T15:46:24 | 49.43 | Lyft | US | US | 02 | 01 | rideshare | 08/2025 | 2012-08-23 | 2012-08-23 | 936 | 936 | 3783 | PURCHASE | 1233.85 | False | False | False | ||||||
| 786361 | 732852505 | 732852505 | 50000 | 48716.72 | 2016-12-29T00:30:55 | 49.89 | walmart.com | US | US | 09 | 99 | online_retail | 07/2022 | 2012-08-23 | 2012-08-23 | 939 | 939 | 3388 | PURCHASE | 1283.28 | False | False | False | ||||||
| 786362 | 732852505 | 732852505 | 50000 | 48666.83 | 2016-12-30T20:10:29 | 72.18 | Uber | US | US | 05 | 01 | rideshare | 05/2024 | 2012-08-23 | 2012-08-23 | 939 | 939 | 3388 | PURCHASE | 1333.17 | False | False | False |